package org.jeecg.modules.sanitation2.mapper;

import java.util.List;
import java.util.Map;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;

import org.jeecg.modules.sanitation2.entity.*;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * @Description: 卫生打分
 * @Author: jeecg-boot
 * @Date:   2021-04-29
 * @Version: V1.0
 */
public interface LwgyScoreSanitationMapper1 extends BaseMapper<LwgyScoreSanitation> {

    List<LwgyScoreSanitation> statisticalQuery(Page<LwgyScoreSanitation> page, @Param(Constants.WRAPPER) QueryWrapper<StatisticalQuery> queryWrapper);

    List<StatisticalDTO> getStatistical();

    List<HealthScoreInfo> queryHealthScoreInfo(String weeks);

    IPage<LwgyScoreSanitation> queryPageListCustomScore(Page<LwgyScoreSanitation> page, @Param("scaleBatches") String scaleBatches,@Param("studentCampus") String studentCampus, @Param("studentCollege") String studentCollege);

    List<ImageZip>findBySql();

    void executeSql(String sql);

    /**批量添加卫生成绩信息*/
    void insertScoreInfo(List<LwgyScoreSanitation> list);

    String  getWeeks(String schoolYear);

    String  getNewWeeks();
    String  getNewId();

    /** 根据批次查询成绩 */
    List<LwgyScoreSanitation> scoreSearch(String scaleBatches);
}
